Release 10.1A: OpenEdge Data Management:
Database Administration
Using a constant table in multiple databases
You can use the Dump and Load utility to copy an existing table from one database into another. For example, instead of writing a procedure to input state data into the state table in a new database, you can dump the table contents from the state table into a copy of the sports database, and then load those records into the state table in another database.
![]()
To copy an existing table from one database into another:
- Start an OpenEdge session with the database (the source) that has the table you want to copy.
- Dump the contents of the table you want to copy into a contents file.
- Switch from the current working database to the target database.
- With the target database as the working database, load the contents of the table.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |